Labels:text | screenshot | font | number | black and white OCR: Header Relevant for named blocks only, the header determines the way that named block or program must be called. The header includes the name, parameter list, and RETURN clause (for a function only). Declaration The part of the block that declares variables, cursors, and Section sub-blocks that are referenced in the execution and exception sections. The declaration section is optional, but if you have one, it must come before the execution and exception sections. Execution The part of the PL/SQL block containing the executable Section statements, the code that is executed by the PL/SQL run-time engine. The execution section contains the IF-THEN-ELSE statements, LOOPs, assignments, and calls to other PL/SQL blocks. Every block must have at least one executable statement in the execution section. Exception The section that handles exceptions to normal processing Section (warnings and error conditions). This final section is optional. li included, control is transferred to this section when an error is encountered. This section then either handles the error or passes control to the block that called the current block. Figure 2 (Top): How a block is divided.
